package com.dao;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.model.Interview;
import com.model.ResumeWorkExperience;
import com.model.ScreenResume;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 简历评估表 Mapper 接口
 * </p>
 *
 * @author Damon
 * @since 2021-04-28
 */
public interface ScreenResumeDao extends BaseMapper<ScreenResume> {
    //查询员工信息以及部门名称
//    @Select("SELECT * from screen_resume")
    public Page<ScreenResume> listPage(Page page);
    //条件查询
    public Page<ScreenResume> listPage(Page page,@Param("screenResume") ScreenResume screenResume);

    //根据resume_key查找专家信息列表
    @Select("SELECT d.realName,c.resume_name AS resumeName,a.*  FROM  screen_resume a, RESUME  c ,users_personal d\n" +
            "  WHERE a.user_key=d.user_account AND a.resume_KEY=C.RESUME_KEY  AND a.user_key=103")
    public Page<ScreenResume> getListAll(Page page);
    public Page<ScreenResume> getListAll(Page page,@Param("screenResume") ScreenResume screenResume);


}
